<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Creating view filters on a percentage range of metric values</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nRestricting report results: Filtering\nCreating a filter based on a condition of metric values");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Creating a filter based on a condition of metric values</h1>
<p>You can create a filter that only displays report results for metrics 
 that fall within certain values. This can allow you to view analysis such 
 as employees between 30% and 60% of tenure length with the company. You 
 can then explore performance metrics within this percentage range of employees 
 and determine where promotions and other actions are necessary. </p>
<p>The steps below show you how to create a filter with a metric qualification.</p>
<h2>Prerequisite</h2>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>You need 
 the Web Use View Filter Editor privilege. This privilege is part of the 
 MicroStrategy OLAP Services product.</p></li>
</ul>
<h2>To create a filter with a condition on metric qualification</h2>
<ol type="1" class="whs1">
	
<li class=P><p>Log into a project in MicroStrategy Web. </p></li>
	
<li class=P><p>Run the report in Grid View. </p></li>
	
<li class=P><p>Right-click a metric on the report and select <span 
 style="font-weight: bold;"><B>Filter On</B></span>. </p></li>
	
<li class=P><p>Select <span style="font-weight: bold;"><B>Add Condition</B></span>. 
 The Filter On Metric dialog box opens.</p></li>
	
<li class=P><p>Select an operator from the drop-down list that describes 
 how you want to filter data, such as Greater than or Equals. </p></li>
	
<li class=P><p>Type the value for the condition you want to restrict 
 data to. This is the value that will be compared against the data in your 
 data source.</p></li>
	
<li class=P><p>Click <span style="font-weight: bold;"><B>OK</B></span>. </p></li>
</ol>
<p class=Steps>&nbsp;</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
